Stored Procedures [dbo].[asi_NewGenTablesRecord]
SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_NewGenTablesRecord
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Codenvarchar(60)120
@TableNamenvarchar(30)60
@Subnvarchar(255)510
@Descnvarchar(255)510
SQL Script
/****** Object:  Stored Procedure dbo.asi_NewGenTablesRecord    Script Date: 7/3/2003 4:58:04 PM ******/

CREATE PROCEDURE dbo.asi_NewGenTablesRecord
@Code nvarchar(60),
@TableName nvarchar(30),
@Sub nvarchar(255),
@Desc nvarchar(255)
AS
BEGIN
insert into Gen_Tables  
(TABLE_NAME, CODE, SUBSTITUTE, UPPER_CODE, DESCRIPTION)
values (@TableName, @Code, @Sub, Upper(@Code), @Desc)
END

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved